Overview: SQL Expressions
Use this operation to enter multiple SQL expressions that will be executed to create new fields in your dataset. The resulting dataset will contain all the original fields as well as the new values generated from the user defined SQL expression queries.
NOTE: CSense provides secure native blocks and operations for building analytics and solutions. The native capabilities provided by CSense can be extended by making use of this feature. When making use of this feature, please ensure that you have validated your extended functions to ensure that they perform as intended and do not introduce stability or security risks to your production system. Do not use scripts or components from untrusted sources.
Properties
Category: |
Add |
Performance risk: |
Low performance risk |
Knowledge required: |
Working knowledge of SQL |
Effect on datasets
How many datasets are required to perform this operation? |
One |
Does it create a new dataset? |
No |
Can you reconfigure this operation? |
Yes |
Can you apply this operation to a locked dataset? |
No |
Does it modify the current dataset in any way? |
Yes |
Requirements
-
This operation needs a dataset that contains at least one field.
Results
-
A modified dataset with the new fields containing the user-defined values produced from the queries.
-
The original fields will be unaffected by this operation. The dataset will however add the new fields (provided that there is enough space inside the dataset for the new fields) that contain the user-defined values.
Related topics: